﻿CREATE TABLE [dbo].[WorkOrderMeasure] (
    [ID]                 INT             IDENTITY (1, 1) NOT NULL,
    [WorkOrderID]        INT             NOT NULL,
    [MeasureType]        INT             NOT NULL,
    [LookupValue]        VARCHAR (500)   NULL,
    [IntegerMin]         INT             NULL,
    [IntegerMax]         INT             NULL,
    [DecimalMin]         NUMERIC (18, 2) NULL,
    [DecimalMax]         NUMERIC (18, 2) NULL,
    [MeasureDescription] VARCHAR (250)   NULL,
    [OptimalLookupValue] VARCHAR (50)    NULL,
    [CalibratedValue]    NVARCHAR (50)   NULL,
	[RequiredComments]	 INT			 NULL,
	[MeasureComments]	 NVARCHAR (250)  NULL	
);

